Term

EntityType | Independent
Logical Entity Name | Term
Default Table Name | AdTerm
Logical Only | NO
Owner | dbo
Definition |
Note |

Term Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(16) | NO |
Name |  | CHAR(35) | NO |
CampusGroupId |  | INTEGER | NO |
StartDate |  | DATETIME | YES |
EndDate |  | DATETIME | YES |
ShiftId |  | INTEGER | NO |
ModFlag |  | CHAR(1) | NO |
IsActive |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
TermId |  | INTEGER | NO |
IsGlobalExtractTerm |  | BIT | YES |
AddDropDate |  | DATETIME | YES |
StudentRegisterEndDate |  | DATETIME | YES |
StudentRegisterStartDate |  | DATETIME | YES |
RevenueUnits |  | NUMERIC(5, 2) | YES |
IsTermOpen |  | BIT | NO |
IsAttendanceRecorded |  | BIT | NO |
OpenRegistrationBeginDateTime |  | DATETIME | YES |
OpenRegistrationEndDateTime |  | DATETIME | YES |
InternalRegistrationBeginDateTime |  | DATETIME | YES |
InternalRegistrationEndDateTime |  | DATETIME | YES |
IsChildTermDatesRuleEnforced |  | BIT | NO |
IsSapTerm |  | BIT | NO |
TermUsage |  | SMALLINT | NO |
SendCourseSectionDataToLms |  | BIT | NO |
SendCourseSectionDataInitialDoneToLms |  | BIT | NO |
SendInstructorAssignmentsToLms |  | BIT | NO |
SendInstructorAssignmentsInitialDoneToLms |  | BIT | NO |
SendStudentRegistrationDataToLms |  | BIT | NO |
SendStudentRegistrationDataInitialDoneToLms |  | BIT | NO |
AuditDesignationDeadline |  | DATETIME | YES |
CourseRefundPolicyId |  | INTEGER | YES |
IsTermSuspendLiftedCampusLinkAmbassador |  | BIT | NO |
SapCalcDaysAfterTermEnd |  | INTEGER | YES |
IsOnlineUsageAllowed |  | BIT | NO |
IsLdaRetainedUnregisteredCourses |  | BIT | YES |
ScheduleChangesType |  | CHAR(1) | YES |
NumberOfDaysToRecalcNotification |  | INTEGER | YES |
IsPrePullRequiredForGlobal |  | BIT | NO |
NumberOfDaysPriorToTermStartDate |  | INTEGER | YES |
NumberOfDaysAfterTermStartDate |  | INTEGER | YES |
IsStandardTerm |  | TINYINT | NO |
StandardTermType |  | CHAR(1) | YES |
FaAcademicCalendar |  | SMALLINT | YES |
IsExcludedCrmIntegration |  | BIT | NO |
TermGroupId |  | INTEGER | YES |
SummerHeaderOrTrailer |  | TINYINT | NO |

Term Keys

Key Name | Key Type | Keys
AdTerm_StartDate_N_N_IDX | Inversion Entry | StartDate
AdTerm_DateLstMod_N_N_IDX | Inversion Entry | LastModifiedDateTime
AdTerm_Code_N_N_IDX | Inversion Entry | Code
AdTerm_TermUsage_N_N_IDX | Inversion Entry | TermUsage
AdTerm_AdTermID_StartDate_EndDate_N_N_IDX | Inversion Entry | TermId, StartDate, EndDate
AdTerm_Active_SyCampusGrpId_AdTermId_U_N_IDX | Alternate Key | IsActive, CampusGroupId, TermId
AdTerm_AdTermID_U_C_IDX | PrimaryKey | TermId
AdTerm_TermUsage_SyCampusGrpId_Descrip_Code_AdTermID_StartDate_EndDate_Active_TermOpen_U_N_IDX | Alternate Key | TermUsage, CampusGroupId, Name, Code, TermId, StartDate, EndDate, IsActive, IsTermOpen

Term Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
TermGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | TermGroupId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
ClassSectionTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentTermConfirmation | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentTransferCredit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodHonor | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCoursePendingRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollRegistrationGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodRegistrationTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStatusChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentTermRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpa | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpa | Non-Identifying | One To Zero or More |  |  |  |  | NO
RegistrationGroupTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
RegistrationRule | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaSapProcessQueueDetailRecord | Non-Identifying | One To Zero or More |  |  |  |  | NO
SchoolStartDateTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdStudentTermSequenceHeader | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdTermCampusRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
adTermExternalMap | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRegistrationSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermProgramAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdTermProgramAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdTermSequenceStartDate | Non-Identifying | One To Zero or More |  |  |  |  | NO
AmCollegeTransferAdvance | Non-Identifying | One To Zero or More |  |  |  |  | NO
Deposit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseDocumentPermit | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCostOfAttendanceTermRepackagingConfig_FAA | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaGlobalExtractChildTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaIntersessionTermRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaIntersessionTermRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardNonTitleIvPaymentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaTermTrack | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaTermTrackProgramAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO
HsRoomMateMatchCriteria | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLeaseScheduledCharge | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLease | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLease | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentBillingStatementBatch | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRevenueSummaryChildTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaPendingChargeRecalcLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaRegBillQueue_Detail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRevenueDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentSubsidiaryAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentSubsidiaryAccountRefund | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaTransCourseAmount | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAthleticDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentServiceType | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentVeteranDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyIndicatorStudentRelation | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentSchoolStatusHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StateReportConfigurationSettingTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStatusChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationshipDataChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
PaidDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
Refund | Non-Identifying | One To Zero or More |  |  |  |  | NO
RegistrationGroupTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
ScheduledDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransactionRegisteredClass | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentBillingStatementBatch | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseDocumentPermit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCoursePendingRegistration | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentCourseStatusChange | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentDegreePathway | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodHonor | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodLesson | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodRegistrationTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentTermSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentTermSummaryRebuildLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpa | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentGpaIncludedCourse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRefundCalculation | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4Calculation | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentSubsidiaryAccountRefund | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentSubsidiaryAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentTransferCredit | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermGroup | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermProgramAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRegistrationSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
TermRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO

Term Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdTerm_OpenRegistrationBeginDateTime_OpenRegistrationEndDateTime | ([OpenRegistrationBeginDateTime] is null and [OpenRegistrationEndDateTime] is null or [OpenRegistrationBeginDateTime] is not null and [OpenRegistrationEndDateTime] is not null and [OpenRegistrationBeginDateTime] <= [OpenRegistrationEndDateTime])
Chk_AdTerm_InternalRegistrationBeginDateTime_InternalRegistrationEndDateTime | ([InternalRegistrationBeginDateTime] is null and [InternalRegistrationEndDateTime] is null or [InternalRegistrationBeginDateTime] is not null and [InternalRegistrationEndDateTime] is not null and [InternalRegistrationBeginDateTime] <= [InternalRegistrationEndDateTime])

Term Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Term | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdTerm | NO |  |  |

Term Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | CourseRegistration
Logical | DegreePathway
Logical | Documents
Logical | Grades/Attendance
Logical | LedgerCard_Billing
Logical | PreviousEd_TransferCredits
Logical | RefundCalculation
Logical | SubsidiaryLedger
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

Term Data Movement Rules

Name | Type | Rule Text/Value